2017-07-03 - 45700 - Break Fix - BI Report WMS501 #CrystalReportsSupport
BREAK FIX
45700 - BI Report WMS501
Problem Summary
Need to fix the duplicate sales rep issue in WMS501 report.
Admin Info
Purpose
|
Need to fix the duplicate sales rep issue in WMS501 report.
|
Requested by
|
Saravanan Lakshmanan
|
Issue Date
|
07-03-2017
|
Resolved by
|
Dhananjay G
|
Resolved Date
|
07-25-2017
|
Document Status
|
Complete
|
Detailed Problem Description
Email from Saravanan Lakshmanan on 07/03/2017:
I have Aubrey Terry and Aubrey Krueger(which are the same person with a recent name change) showing up on this report(BI report WMS501) for the same order. Furthermore, this order should not be on the report at all. Can you kindly look into this?
Solution Analysis and Recommendations
1. Need to check the logic in the report.
2. Need to check infoset joins.
3. Need to validate the report with SAP infoset.
4. Need to place the report in BI development and inform NEC for promotion after successful validation.
5. Need to check the production version after promotion.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Resolution
1. Add the Language field TVGRT-SPRAS to infoset ZSD_VASEXCEPTIONS.
2. Add the below condition to the report in record selection formula section:
{ZSDVAS.TVGRT-SPRAS} = 'EN'
3. The report is validated against SAP infoset.
4. T
he report was placed in BI development and NEC informed for promotion after successful validation.
Release Information
2017-07-13 - 45700 - Rel Notes - BI Report WMS501 - Release 001
2017-07-25 - 45700 - Rel Notes - BI Report WMS501 - Release 002